/***************************************************************

CREATE AND LOAD THE STYLE TABLES

Author:	Brian K. McDonald, MCSD, MCDBA
Date:	3/9/2009

****************************************************************/

CREATE TABLE SSRS_Styles
(
	StyleID	INT PRIMARY KEY IDENTITY(1,1)
	, StyleName				VARCHAR(50)
	, ReportBGColor			VARCHAR(100)
	, ReportTitleColor		VARCHAR(100)
	, TableHeaderBGColor	VARCHAR(100)
	, TableHeaderFontColor	VARCHAR(100)
	, TableDetailsBGColor	VARCHAR(100)
	, TableDetailsFontColor VARCHAR(100)
)
GO

--Standard Theme 1
INSERT INTO SSRS_Styles 
	(StyleName, ReportBGColor, ReportTitleColor, TableHeaderBGColor
	, TableHeaderFontColor, TableDetailsBGColor, TableDetailsFontColor)
VALUES 	('Standard Mono-Chrome','White','Black','#6ca6cd', 'White', 'White','Black')

--Standard Theme 2
INSERT INTO SSRS_Styles 
	(StyleName, ReportBGColor, ReportTitleColor, TableHeaderBGColor
	, TableHeaderFontColor, TableDetailsBGColor, TableDetailsFontColor)
VALUES ('Standard Go-Green','White','Green','PaleGreen', 'Black', 'White','Black')

--Standard Theme 3
INSERT INTO SSRS_Styles 
	(StyleName, ReportBGColor, ReportTitleColor, TableHeaderBGColor
	, TableHeaderFontColor, TableDetailsBGColor, TableDetailsFontColor)
VALUES ('Standard McPorting','White','Blue','Red', 'White', 'White','Black')

--Standard Theme 4
INSERT INTO SSRS_Styles 
	(StyleName, ReportBGColor, ReportTitleColor, TableHeaderBGColor
	, TableHeaderFontColor, TableDetailsBGColor, TableDetailsFontColor)
VALUES ('Standard Star Wars','Black','Silver','Gold', 'Black', 'Black','Silver')


CREATE TABLE SSRS_Style_Preferences
(
	PreferenceID	INT PRIMARY KEY IDENTITY(1,1)
	, UserName		VARCHAR(50)
	, StyleID		INT DEFAULT 1
)
GO


INSERT INTO SSRS_Style_Preferences (UserName, StyleID) VALUES ('Default',1)
INSERT INTO SSRS_Style_Preferences (UserName, StyleID) VALUES ('GreenMan',2)
INSERT INTO SSRS_Style_Preferences (UserName, StyleID) VALUES ('BrianMcDonald',3)
INSERT INTO SSRS_Style_Preferences (UserName, StyleID) VALUES ('DarthVader',4)